use ApiAuth


INSERT INTO [Company] ([Id],[Name] ,[Domain] ,[AdPath] ,[AdUser],[AdPassword])
 VALUES
  (1, 'Lacoste','vesuvio',	'LDAP://vesuvio.argentina/DC=vesuvio,DC=argentina', 'sromero', 'sandra');


INSERT INTO [Company] ([Id],[Name] ,[Domain] ,[AdPath] ,[AdUser],[AdPassword])
 VALUES
  (2, 'Penguin',	'vesuvio',	'LDAP://vesuvio.argentina/DC=vesuvio,DC=argentina', 'sromero', 'sandra');


INSERT INTO [Company] ([Id],[Name] ,[Domain] ,[AdPath] ,[AdUser],[AdPassword])
 VALUES
  (3, 'Paula',	'vesuvio',	'LDAP://vesuvio.argentina/DC=vesuvio,DC=argentina', 'sromero', 'sandra');


INSERT INTO [Company] ([Id],[Name] ,[Domain] ,[AdPath] ,[AdUser],[AdPassword])
 VALUES
  (4, 'Outlet',	'vesuvio',	'LDAP://vesuvio.argentina/DC=vesuvio,DC=argentina', 'sromero', 'sandra');
  
INSERT INTO [Company] ([Id],[Name] ,[Domain] ,[AdPath] ,[AdUser],[AdPassword])
 VALUES
  (5, 'Cacharel','vesuvio',	'LDAP://vesuvio.argentina/DC=vesuvio,DC=argentina', 'sromero', 'sandra') ;
  
  
  --Crm Company
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (1,5,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (1,6,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (2,5,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (2,6,1);

  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (4,5,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (4,6,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (5,5,1);
  insert into CompanyApplication (CompanyId, ApplicationId, AppActive)
  values (5,6,1);

    
  go
  
 use CrmContacto
  
insert into Empresa  (Id,	Nombre,	MailBienvenidaSubject,	PathMailBienvenida	,CssFilePath,	LogoImgFilePath)
values 
(1,	'Lacoste', 'Bienvenido a Lacoste', 'D:\Programming\Proyectos\Lacoste\Codigo\Crm\trunk\src\CrmContacto.PtoVenta.Host\HtmlMail\MailBienvenida.htm', 'Cacharel.css', '/Images/Company/Lacoste.png');

  
insert into Empresa  (Id,	Nombre,	MailBienvenidaSubject,	PathMailBienvenida	,CssFilePath,	LogoImgFilePath)
values 
(2,	'Penguin', 'Bienvenido a Penguin', 'D:\Programming\Proyectos\Lacoste\Codigo\Crm\trunk\src\CrmContacto.PtoVenta.Host\HtmlMail\MailBienvenida.htm', 'Outlet.css', '/Images/Company/Penguin.png');

insert into Empresa  (Id,	Nombre,	MailBienvenidaSubject,	PathMailBienvenida	,CssFilePath,	LogoImgFilePath)
values 
(3,	'Paula', 'Bienvenido a Paula', 'D:\Programming\Proyectos\Lacoste\Codigo\Crm\trunk\src\CrmContacto.PtoVenta.Host\HtmlMail\MailBienvenida.htm', 'Cacharel.css', '/Images/Company/Paula.png');


insert into Empresa  (Id,	Nombre,	MailBienvenidaSubject,	PathMailBienvenida	,CssFilePath,	LogoImgFilePath)
values 
(4,	'Outlet', 'Bienvenido al Outlet Lacoste', 'D:\Programming\Proyectos\Lacoste\Codigo\Crm\trunk\src\CrmContacto.PtoVenta.Host\HtmlMail\MailBienvenida.htm', 'Outlet.css', '/Images/Company/Lacoste.png');

insert into Empresa  (Id,	Nombre,	MailBienvenidaSubject,	PathMailBienvenida	,CssFilePath,	LogoImgFilePath)
values 
(5,	'Cacharel', 'Bienvenido a Cacharel', 'D:\Programming\Proyectos\Lacoste\Codigo\Crm\trunk\src\CrmContacto.PtoVenta.Host\HtmlMail\MailBienvenida.htm', 'Cacharel.css', '/Images/Company/Cacharel.png');


